package jw.repository.agent;


import jw.model.agent.WxAgentBalanceInfo;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;

import java.util.List;


public interface WxAgentBalanceInfoRepository extends JpaRepository<WxAgentBalanceInfo,Integer>, JpaSpecificationExecutor<WxAgentBalanceInfo> {

    @Query("select a from WxAgentBalanceInfo a where a.agentId =?1 and a.isDelete =?2 and a.type =?3 and a.year =?4 and a.month =?5")
    List<WxAgentBalanceInfo>findInfoList(Integer agentId,Integer isDelete,Integer type,Integer year,Integer month);

}
